set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

--CREATEd:02/08/2010
--Author: nnamthach@gmail.com
Create procedure [dbo].[procUser_get_ByUsername](
@Username as nchar(100)
)
AS
BEGIN 
SELECT
	ID,
	Username,
	Password,
	Email,
	Regdate,
	Ip,
	Firstname,
	Lastname,
	Birthdate,
	Birthplace,
	Ssn,
	ANAL_U0,
	ANAL_U1,
	ANAL_U2,
	ANAL_U3,
	ANAL_U4,
	ANAL_U5,
	ANAL_U6,
	ANAL_U7,
	ANAL_U8,
	ANAL_U9
	
FROM  dbo.[User]
WHERE 	(
		@Username = Username 
)
END


